<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->


<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->

<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->

<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->

<!DOCTYPE html
  PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="en-us" xml:lang="en-us">
<head>
      <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
   
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="DC.Type" content="topic">
<meta name="DC.Title" content="Querying ClickHouse Information">
<meta name="product" content="">
<meta name="DC.Relation" scheme="URI" content="en-us_topic_0000001792543156.html">
<meta name="prodname" content="">
<meta name="version" content="">
<meta name="brand" content="30-OceanProtect Appliance 1.5.0-1.6.0 Help Center">
<meta name="DC.Publisher" content="20240608">
<meta name="DC.Format" content="XHTML">
<meta name="DC.Identifier" content="EN-US_TOPIC_0000001792383468">
<meta name="DC.Language" content="en-us">
<link rel="stylesheet" type="text/css" href="public_sys-resources/commonltr.css">
<title>Querying ClickHouse Information</title>
</head>
<body style="clear:both; padding-left:10px; padding-top:5px; padding-right:5px; padding-bottom:5px"><a name="EN-US_TOPIC_0000001792383468"></a><a name="EN-US_TOPIC_0000001792383468"></a>

<h1 class="topictitle1">Querying ClickHouse Information</h1>
<div><div class="section"><h4 class="sectiontitle">Procedure</h4><ol><li><span>Choose <span class="uicontrol" id="EN-US_TOPIC_0000001792383468__en-us_topic_0000001839142377_uicontrol12263171215409"><b><span id="EN-US_TOPIC_0000001792383468__en-us_topic_0000001839142377_text1926371213406"><strong>Protection</strong></span> &gt; Big Data &gt; ClickHouse</b></span>.</span></li><li><span>On the <span class="uicontrol"><b><span><strong>Cluster</strong></span></b></span> tab page, query the ClickHouse cluster information.</span><p><ol type="a"><li>This page displays information about ClickHouse clusters registered with the <span>OceanProtect Appliance</span>.<p><a href="#EN-US_TOPIC_0000001792383468__table14170211115420">Table 1</a> describes related parameters.</p>

<div class="tablenoborder"><a name="EN-US_TOPIC_0000001792383468__table14170211115420"></a><a name="table14170211115420"></a><table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000001792383468__table14170211115420" frame="border" border="1" rules="all"><caption><b>Table 1 </b>ClickHouse cluster information</caption><colgroup><col style="width:19.189999999999998%"><col style="width:80.81%"></colgroup><thead align="left"><tr><th align="left" class="cellrowborder" valign="top" width="19.189999999999998%" id="mcps1.3.1.2.2.2.1.1.3.2.3.1.1"><p>Parameter</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="80.81%" id="mcps1.3.1.2.2.2.1.1.3.2.3.1.2"><p>Description</p>
</th>
</tr>
</thead>
<tbody><tr><td class="cellrowborder" valign="top" width="19.189999999999998%" headers="mcps1.3.1.2.2.2.1.1.3.2.3.1.1 "><p><span><strong>Name</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="80.81%" headers="mcps1.3.1.2.2.2.1.1.3.2.3.1.2 "><p>ClickHouse cluster name.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="19.189999999999998%" headers="mcps1.3.1.2.2.2.1.1.3.2.3.1.1 "><p><span><strong>Status</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="80.81%" headers="mcps1.3.1.2.2.2.1.1.3.2.3.1.2 "><p>ClickHouse cluster status.</p>
<ul><li><span><strong>Online</strong></span>: If the connections between the proxy host and all nodes in the ClickHouse cluster are normal, <span class="uicontrol"><b><span><strong>Status</strong></span></b></span> is <span class="uicontrol"><b><span><strong>Online</strong></span></b></span>.</li><li><span><strong>Offline</strong></span>: If the connections between the proxy host and all nodes in the ClickHouse cluster are abnormal, <span class="uicontrol"><b><span><strong>Status</strong></span></b></span> is <span class="uicontrol"><b><span><strong>Offline</strong></span></b></span>.</li><li><span><strong>Exception</strong></span>: If the connections between the proxy host and all nodes in the ClickHouse cluster are abnormal, <span class="uicontrol"><b><span><strong>Status</strong></span></b></span> is <span class="uicontrol"><b><span><strong>Exception</strong></span></b></span>.</li></ul>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="19.189999999999998%" headers="mcps1.3.1.2.2.2.1.1.3.2.3.1.1 "><p><span><strong>Version</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="80.81%" headers="mcps1.3.1.2.2.2.1.1.3.2.3.1.2 "><p>ClickHouse version number.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="19.189999999999998%" headers="mcps1.3.1.2.2.2.1.1.3.2.3.1.1 "><p><span><strong>Owner</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="80.81%" headers="mcps1.3.1.2.2.2.1.1.3.2.3.1.2 "><p>User to whom resources of a vStore are allocated for management.</p>
</td>
</tr>
</tbody>
</table>
</div>
</li><li>Click the cluster name to view the cluster basic information and the information about the database or table set related to the cluster.</li></ol>
</p></li><li><span>On the <span class="uicontrol"><b><span><strong>Databases</strong></span></b></span> tab page, query the ClickHouse database information.</span><p><ol type="a"><li>This page displays the details about the ClickHouse database.<p><a href="#EN-US_TOPIC_0000001792383468__table5610162112314">Table 2</a> describes related parameters.</p>

<div class="tablenoborder"><a name="EN-US_TOPIC_0000001792383468__table5610162112314"></a><a name="table5610162112314"></a><table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000001792383468__table5610162112314" frame="border" border="1" rules="all"><caption><b>Table 2 </b>ClickHouse database parameters</caption><colgroup><col style="width:25.55%"><col style="width:74.45%"></colgroup><thead align="left"><tr><th align="left" class="cellrowborder" valign="top" width="25.55%" id="mcps1.3.1.2.3.2.1.1.2.2.3.1.1"><p>Parameter</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="74.45%" id="mcps1.3.1.2.3.2.1.1.2.2.3.1.2"><p>Description</p>
</th>
</tr>
</thead>
<tbody><tr><td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.3.2.1.1.2.2.3.1.1 "><p><span><strong>Name</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.3.2.1.1.2.2.3.1.2 "><p>Database name.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.3.2.1.1.2.2.3.1.1 "><p><span><strong>Owning Cluster</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.3.2.1.1.2.2.3.1.2 "><p>Cluster to which a database belongs.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.3.2.1.1.2.2.3.1.1 "><p><span><strong>SLAs</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.3.2.1.1.2.2.3.1.2 "><p>If an SLA has been associated with the ClickHouse database, the SLA name is displayed. Otherwise, <span class="uicontrol"><b>--</b></span> is displayed.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.3.2.1.1.2.2.3.1.1 "><p><span><strong>SLA Compliance</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.3.2.1.1.2.2.3.1.2 "><div class="p">Whether a backup job is successfully executed based on the backup frequency or backup window set in the SLA.<ul id="EN-US_TOPIC_0000001792383468__en-us_topic_0000001792344110_en-us_topic_0000001792344094_ul1823814519293"><li id="EN-US_TOPIC_0000001792383468__en-us_topic_0000001792344110_en-us_topic_0000001792344094_li9238184572919">If the backup time of a backup job (except for the first full backup) meets the backup time window or backup interval requirements and the backup job is executed successfully, SLA compliance is met.</li><li id="EN-US_TOPIC_0000001792383468__en-us_topic_0000001792344110_en-us_topic_0000001792344094_li189142052112912">If the backup time does not meet the backup time window or backup frequency requirements, for example, if the backup frequency set in the SLA for a backup job is once every half an hour but the backup time exceeds half an hour, SLA compliance is missed. In this case, you are advised to adjust the backup frequency or backup window.</li></ul>
</div>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.3.2.1.1.2.2.3.1.1 "><p><span><span><strong>Protection Status</strong></span></span></p>
</td>
<td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.3.2.1.1.2.2.3.1.2 "><p>Whether the ClickHouse database has been protected.</p>
<ul><li><span><strong>Unprotected</strong></span>: The ClickHouse database is not associated with an SLA, or the ClickHouse database is associated with an SLA but protection is disabled.</li><li><span><strong>Protected</strong></span>: The ClickHouse database is associated with an SLA and protection has been activated.</li><li><span><strong>Creating</strong></span>: The ClickHouse database is associated with an SLA and protection is being created.</li></ul>
</td>
</tr>
</tbody>
</table>
</div>
</li></ol><ol type="a" start="2"><li>Click the name and check the overview, copy information, and related jobs. <ul id="EN-US_TOPIC_0000001792383468__en-us_topic_0000001792344110_ul865415431221"><li id="EN-US_TOPIC_0000001792383468__en-us_topic_0000001792344110_li165311431228">Overview<p id="EN-US_TOPIC_0000001792383468__en-us_topic_0000001792344110_p18940145516325"><a name="EN-US_TOPIC_0000001792383468__en-us_topic_0000001792344110_li165311431228"></a><a name="en-us_topic_0000001792344110_li165311431228"></a>Display the SLA information, job execution time, and total number of copies.</p>
</li><li id="EN-US_TOPIC_0000001792383468__en-us_topic_0000001792344110_li15654174342214">Copy data<p id="EN-US_TOPIC_0000001792383468__en-us_topic_0000001792344110_p565454392218"><a name="EN-US_TOPIC_0000001792383468__en-us_topic_0000001792344110_li15654174342214"></a><a name="en-us_topic_0000001792344110_li15654174342214"></a>You can search for copies by year, month, and day.</p>
<p id="EN-US_TOPIC_0000001792383468__en-us_topic_0000001792344110_p6521122942916">If <span><img id="EN-US_TOPIC_0000001792383468__en-us_topic_0000001792344110_image7611125417346" src="en-us_image_0000001792344154.png"></span> is displayed below the time, a copy exists at the time.</p>
</li><li id="EN-US_TOPIC_0000001792383468__en-us_topic_0000001792344110_li0654134382213">Related jobs<p id="EN-US_TOPIC_0000001792383468__en-us_topic_0000001792344110_p1747754963312"><a name="EN-US_TOPIC_0000001792383468__en-us_topic_0000001792344110_li0654134382213"></a><a name="en-us_topic_0000001792344110_li0654134382213"></a>Displays backup and restoration jobs.</p>
</li></ul>
</li></ol>
</p></li><li><span>On the <span class="uicontrol"><b><span><strong>Table Sets</strong></span></b></span> tab page, view the information about the ClickHouse table set.</span><p><ol type="a"><li>This page displays the details about the ClickHouse table set.<p><a href="#EN-US_TOPIC_0000001792383468__table19966163675618">Table 3</a> describes related parameters.</p>

<div class="tablenoborder"><a name="EN-US_TOPIC_0000001792383468__table19966163675618"></a><a name="table19966163675618"></a><table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000001792383468__table19966163675618" frame="border" border="1" rules="all"><caption><b>Table 3 </b>ClickHouse table set parameters</caption><colgroup><col style="width:25.55%"><col style="width:74.45%"></colgroup><thead align="left"><tr><th align="left" class="cellrowborder" valign="top" width="25.55%" id="mcps1.3.1.2.4.2.1.1.2.2.3.1.1"><p>Parameter</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="74.45%" id="mcps1.3.1.2.4.2.1.1.2.2.3.1.2"><p>Description</p>
</th>
</tr>
</thead>
<tbody><tr><td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.4.2.1.1.2.2.3.1.1 "><p><span><strong>Name</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.4.2.1.1.2.2.3.1.2 "><p>Name of a ClickHouse table set.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.4.2.1.1.2.2.3.1.1 "><p><span><strong>Owning Cluster</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.4.2.1.1.2.2.3.1.2 "><p>Cluster to which the ClickHouse table set belongs.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.4.2.1.1.2.2.3.1.1 "><p><span><strong>Owning Database</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.4.2.1.1.2.2.3.1.2 "><p>Database to which the ClickHouse table set belongs.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.4.2.1.1.2.2.3.1.1 "><p><span><strong>SLAs</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.4.2.1.1.2.2.3.1.2 "><p>If an SLA has been associated with the ClickHouse table set, the SLA name is displayed. Otherwise, <span class="uicontrol"><b>--</b></span> is displayed.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.4.2.1.1.2.2.3.1.1 "><p><span><strong>SLA Compliance</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.4.2.1.1.2.2.3.1.2 "><div class="p">Whether a backup job is successfully executed based on the backup frequency or backup window set in the SLA.<ul id="EN-US_TOPIC_0000001792383468__en-us_topic_0000001792344110_en-us_topic_0000001792344094_ul1823814519293_1"><li id="EN-US_TOPIC_0000001792383468__en-us_topic_0000001792344110_en-us_topic_0000001792344094_li9238184572919_1">If the backup time of a backup job (except for the first full backup) meets the backup time window or backup interval requirements and the backup job is executed successfully, SLA compliance is met.</li><li id="EN-US_TOPIC_0000001792383468__en-us_topic_0000001792344110_en-us_topic_0000001792344094_li189142052112912_1">If the backup time does not meet the backup time window or backup frequency requirements, for example, if the backup frequency set in the SLA for a backup job is once every half an hour but the backup time exceeds half an hour, SLA compliance is missed. In this case, you are advised to adjust the backup frequency or backup window.</li></ul>
</div>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.4.2.1.1.2.2.3.1.1 "><p><span><span><strong>Protection Status</strong></span></span></p>
</td>
<td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.4.2.1.1.2.2.3.1.2 "><p>Whether the ClickHouse table set has been protected.</p>
<ul><li><span><strong>Unprotected</strong></span>: The ClickHouse table set is not associated with an SLA, or it is associated with an SLA but protection is disabled.</li><li><span><strong>Protected</strong></span>: The ClickHouse table set is associated with an SLA and protection is enabled.</li><li><span><strong>Creating</strong></span>: The ClickHouse table set is associated with an SLA and protection is being created.</li></ul>
</td>
</tr>
</tbody>
</table>
</div>
</li><li>Click the name and check the overview, copy information, and related jobs. <ul id="EN-US_TOPIC_0000001792383468__en-us_topic_0000001792344110_ul865415431221_1"><li id="EN-US_TOPIC_0000001792383468__en-us_topic_0000001792344110_li165311431228_1">Overview<p id="EN-US_TOPIC_0000001792383468__en-us_topic_0000001792344110_p18940145516325_1"><a name="EN-US_TOPIC_0000001792383468__en-us_topic_0000001792344110_li165311431228_1"></a><a name="en-us_topic_0000001792344110_li165311431228_1"></a>Display the SLA information, job execution time, and total number of copies.</p>
</li><li id="EN-US_TOPIC_0000001792383468__en-us_topic_0000001792344110_li15654174342214_1">Copy data<p id="EN-US_TOPIC_0000001792383468__en-us_topic_0000001792344110_p565454392218_1"><a name="EN-US_TOPIC_0000001792383468__en-us_topic_0000001792344110_li15654174342214_1"></a><a name="en-us_topic_0000001792344110_li15654174342214_1"></a>You can search for copies by year, month, and day.</p>
<p id="EN-US_TOPIC_0000001792383468__en-us_topic_0000001792344110_p6521122942916_1">If <span><img id="EN-US_TOPIC_0000001792383468__en-us_topic_0000001792344110_image7611125417346_1" src="en-us_image_0000001792344154.png"></span> is displayed below the time, a copy exists at the time.</p>
</li><li id="EN-US_TOPIC_0000001792383468__en-us_topic_0000001792344110_li0654134382213_1">Related jobs<p id="EN-US_TOPIC_0000001792383468__en-us_topic_0000001792344110_p1747754963312_1"><a name="EN-US_TOPIC_0000001792383468__en-us_topic_0000001792344110_li0654134382213_1"></a><a name="en-us_topic_0000001792344110_li0654134382213_1"></a>Displays backup and restoration jobs.</p>
</li></ul>
</li></ol>
</p></li></ol>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="en-us_topic_0000001792543156.html">ClickHouse Cluster Environment</a></div>
</div>
</div>

<div class="hrcopyright"><hr size="2"></div><div class="hwcopyright">Copyright &copy; Huawei Technologies Co., Ltd.</div></body>
</html>